Small Materialized Aggregates: A Light Weight Index Structure for Data Warehousing
نویسنده
چکیده
Small Materialized Aggregates (SMAs for short) are considered a highly flexible and versatile alternative for materialized data cubes. The basic idea is to compute many aggregate values for small to medium-sized buckets of tuples. These aggregates are then used to speed up query processing. We present the general idea and present an application of SMAs to the TPC-D benchmark. We show that exploiting SMAs for TPC-D Query 1 results in a speed up of two orders of magnitude. Then, we investigate the problem of query processing in the presence of SMAs. Last, we briefly discuss some further tuning possibilities for SMAs.
منابع مشابه
Using Materialized Views To Speed Up Data Warehousing
Running analytical queries directly against the huge raw data volume of a data warehouse results in unacceptable query performance. The solution to this problem is storing materialized views in the warehouse, which pre-aggregate the data and thus avoid raw data access and speed up queries. In this paper, at first the problems concerning the selection of the right pre-aggregations and their util...
متن کاملAugmented Inherited Multi-Index Structure for Maintenaince of Materialized Path Query Views
Materialized complex object-oriented views are a promising technique for the integration of heterogeneous databases and the development of powerful data warehousing systems. Path query views are virtual classes formed from selection queries that specify a predicate upon the value of an aggregation hierarchy path. The primary diierence between previous work regarding OODB indexing and the eecien...
متن کاملPhysical Database Design for Data Warehouses
Data warehousing has quickly evolved into a unique and popular business application class. A data warehouse stores materialized views of data from one or more remote sources, with the purpose of efficiently implementing decision support or OLAP (On-Line Analytical Processing) queries. One of more important decisions in designing data warehouse is the selection of materialized views to be mainta...
متن کاملMaterialized Views in Oracle
Oracle Materialized Views (MVs) are designed for data warehousing and replication. For data warehousing, MVs based on inner/outer equijoins with optional aggregation, can be refreshed on transaction boundaries, on demand, or periodically. Refreshes are optimized for bulk loads and can use a multi-MV scheduler. MVs based on subqueries on remote tables support bidirectional replication. Optimizat...
متن کاملDesigning and Implementing an Object Relational Data Warehousing System
In this paper we present some of the results achieved while realizing an international research project aiming at the design and development of an Object–Relational Data Warehousing System (ORDAWA). Important goals of the project are to develop techniques for the integration and consolidation of different external data sources in an object–relational data warehouse, the construction and mainten...
متن کامل